﻿CREATE TABLE [dbo].[ImagePattern]
(
	[Id] BIGINT NOT NULL IDENTITY(1,1) PRIMARY KEY,
	[ImageId] BIGINT NOT NULL,
	[PatternDescriptionId] BIGINT NOT NULL,
	[MatchPercentage] FLOAT NOT NULL,
	CONSTRAINT [DF_ImagePattern_Image] FOREIGN KEY ([ImageId]) 
		REFERENCES [dbo].[Image] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [DF_ImagePattern_Pattern] FOREIGN KEY ([PatternDescriptionId]) 
		REFERENCES [dbo].[PatternDescription] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
)
